// 从环境变量或配置文件中获取数据库凭据  
const DB_HOST = process.env.DB_HOST;
const DB_USER = process.env.DB_USER;
const DB_PASSWORD = process.env.DB_PASSWORD;
const DB_DATABASE = process.env.DB_DATABASE;
const DB_PORT = Number(process.env.DB_PORT) || 3306; // 确保端口是数字类型  

//需要连接的mysql的配置语句
module.exports = {
    mysql: {
        host: DB_HOST,
        user: DB_USER,
        password: DB_PASSWORD,
        database: DB_DATABASE,
        port: DB_PORT, // 确保端口是数字类型  
        multipleStatements: true // 支持执行多条 sql 语句
    }
}